/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : shopping

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 19/11/2020 11:59:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for shop_car
-- ----------------------------
DROP TABLE IF EXISTS `shop_car`;
CREATE TABLE `shop_car` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_xh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `goods_id` int DEFAULT NULL,
  `car_num` int DEFAULT '1',
  `car_price` float(10,2) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of shop_car
-- ----------------------------
BEGIN;
INSERT INTO `shop_car` VALUES (12, NULL, NULL, 3, 1, 21.00, '2020-11-17 17:49:54', '2020-11-17 17:49:54', NULL);
INSERT INTO `shop_car` VALUES (13, NULL, NULL, 2, 1, 21.00, '2020-11-17 17:50:11', '2020-11-17 17:50:11', NULL);
INSERT INTO `shop_car` VALUES (14, NULL, NULL, 12, 1, 21.00, '2020-11-17 17:50:21', '2020-11-17 17:50:21', NULL);
INSERT INTO `shop_car` VALUES (15, NULL, NULL, 2, 1, 21.00, '2020-11-17 17:51:21', '2020-11-17 17:51:21', NULL);
INSERT INTO `shop_car` VALUES (16, NULL, NULL, 2, 1, 21.00, '2020-11-17 17:51:32', '2020-11-17 17:51:32', NULL);
INSERT INTO `shop_car` VALUES (17, NULL, NULL, 2, 1, 21.00, '2020-11-17 17:51:41', '2020-11-17 17:51:41', NULL);
INSERT INTO `shop_car` VALUES (20, NULL, NULL, 4, 4, 21.00, '2020-11-17 19:06:00', '2020-11-17 19:06:00', NULL);
INSERT INTO `shop_car` VALUES (22, NULL, 1, 3, 1, 21.00, '2020-11-17 19:37:48', '2020-11-17 19:37:48', NULL);
INSERT INTO `shop_car` VALUES (23, NULL, 1, 3, 1, 21.00, '2020-11-17 19:37:55', '2020-11-17 19:37:55', NULL);
INSERT INTO `shop_car` VALUES (37, NULL, NULL, 6, 1, 21.00, '2020-11-18 22:55:43', '2020-11-18 22:55:43', NULL);
COMMIT;

-- ----------------------------
-- Table structure for shop_favor
-- ----------------------------
DROP TABLE IF EXISTS `shop_favor`;
CREATE TABLE `shop_favor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `goods_id` int DEFAULT NULL,
  `favor_price` float(10,2) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_xh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of shop_favor
-- ----------------------------
BEGIN;
INSERT INTO `shop_favor` VALUES (2, 1, 3, 21.00, '2020-11-17 11:53:04', '2020-11-17 11:53:04', NULL, '10086');
INSERT INTO `shop_favor` VALUES (3, 1, 4, 21.00, '2020-11-17 11:55:03', '2020-11-17 11:55:03', NULL, '10086');
INSERT INTO `shop_favor` VALUES (4, 1, 6, 21.00, '2020-11-17 11:56:42', '2020-11-17 11:56:42', NULL, '10086');
INSERT INTO `shop_favor` VALUES (5, 1, 2, 21.00, '2020-11-17 12:01:23', '2020-11-17 12:01:23', NULL, '10086');
COMMIT;

-- ----------------------------
-- Table structure for shop_goods
-- ----------------------------
DROP TABLE IF EXISTS `shop_goods`;
CREATE TABLE `shop_goods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `goods_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '照片',
  `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `goods_price` float(255,2) DEFAULT NULL COMMENT '价格',
  `discount_price` float(255,2) DEFAULT NULL COMMENT '折扣价格',
  `goods_details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '详细',
  `goods_num` int DEFAULT '1000' COMMENT '库存',
  `browse` int DEFAULT '0' COMMENT '浏览量',
  `purchase` int DEFAULT '0' COMMENT '购买量',
  `favorites` int DEFAULT '0' COMMENT '收藏次数',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型',
  `flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标识',
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of shop_goods
-- ----------------------------
BEGIN;
INSERT INTO `shop_goods` VALUES (1, 'img/img1.jpg', '手撕面包', 21.00, 24.00, '手撕面包--即时优惠21元', 1000, 8, 0, 4, '镇店爆款', '良品铺子', '2020-11-09 21:15:28', '2020-11-09 21:15:28', '');
INSERT INTO `shop_goods` VALUES (2, 'img/img2.jpg', '风味干肉片', 21.00, 21.00, '风味干肉片--即时优惠21元', 1000, 40, 0, 2, '镇店爆款', '良品铺子', '2020-11-09 21:15:38', '2020-11-09 21:15:38', '');
INSERT INTO `shop_goods` VALUES (3, 'img/img3.jpg', '每日坚果', 21.00, 23.00, '每日坚果--即时优惠21元', 1000, 48, 0, 1, '镇店爆款', '良品铺子', '2020-11-09 21:15:42', '2020-11-09 21:15:42', '');
INSERT INTO `shop_goods` VALUES (4, 'img/img4.jpg', '板栗仁', 21.00, 21.00, '板栗仁--即时优惠21元', 1000, 30, 0, 1, '镇店爆款', '良品铺子', '2020-11-09 21:15:45', '2020-11-09 21:15:45', '');
INSERT INTO `shop_goods` VALUES (5, 'img/img5.jpg', '芒果干', 21.00, 21.00, '芒果干--即时优惠21元', 1000, 0, 0, 1, '镇店爆款', '良品铺子', '2020-11-09 21:15:49', '2020-11-09 21:15:49', '');
INSERT INTO `shop_goods` VALUES (6, 'img/img6.jpg', '夏威夷果', 21.00, 1.00, '夏威夷果--即时优惠21元', 1000, 3, 0, 1, '量贩专区', '良品铺子', '2020-11-09 21:15:52', '2020-11-09 21:15:52', '');
INSERT INTO `shop_goods` VALUES (7, 'img/img7.jpg', '零食大礼包', 21.00, 21.00, '零食大礼包--即时优惠21元', 1000, 1, 0, 3, '量贩专区', '良品铺子', '2020-11-09 21:15:55', '2020-11-09 21:15:55', '');
INSERT INTO `shop_goods` VALUES (8, 'img/img8.jpg', '鸭子啊', 21.00, 61.00, '鸭杂--即时优惠21元', 1000, 5, 0, 0, '量贩专区', '良品铺子', '2020-11-09 21:15:59', '2020-11-09 21:15:59', '');
INSERT INTO `shop_goods` VALUES (9, 'img/img9.jpg', '鸭子啊', 21.00, 21.00, '鸭子--即时优惠21元', 1000, 5, 0, 0, '量贩专区', '良品铺子', '2020-11-09 21:16:04', '2020-11-09 21:16:04', '');
INSERT INTO `shop_goods` VALUES (10, 'img/img10.jpg', '鸭子', 21.00, 20.00, '鸭子全--即时优惠21元', 1000, 0, 0, 0, '量贩专区', '良品铺子', '2020-11-09 21:16:08', '2020-11-09 21:16:08', '');
INSERT INTO `shop_goods` VALUES (11, 'img/img10.jpg', '鸭肠子', 21.00, 7.00, '零食大礼包--即时优惠2', 1000, 88, 0, 0, '坚果炒货', '良品铺子', '2020-11-10 19:49:26', '2020-11-10 19:49:26', '');
INSERT INTO `shop_goods` VALUES (12, 'img/img10.jpg', '鸭肝子', 21.00, 8.00, '鸭子--即时优惠21元', 1000, 2, 0, 0, '坚果炒货', '良品铺子', '2020-11-14 15:44:24', '2020-11-14 15:44:24', '');
INSERT INTO `shop_goods` VALUES (13, 'img/img10.jpg', '牛肉干', 21.00, 2.00, '零食大礼包--即时优惠2', 1000, 0, 0, 0, '肉类卤味', '良品铺子', '2020-11-14 15:44:49', '2020-11-14 15:44:49', '');
INSERT INTO `shop_goods` VALUES (14, 'img/img10.jpg', '牛干', 21.00, 71.00, '鸭子--即时优惠21元', 1000, 0, 0, 0, '肉类卤味', '良品铺子', '2020-11-14 15:44:55', '2020-11-14 15:44:55', '');
INSERT INTO `shop_goods` VALUES (15, 'img/img10.jpg', '干干干', 21.00, 21.00, '每日坚果--即时优惠21元', 1000, 0, 0, 0, '肉类卤味', '良品铺子', '2020-11-14 15:45:03', '2020-11-14 15:45:03', '');
INSERT INTO `shop_goods` VALUES (16, 'img/img10.jpg', '猪肉干', 21.00, 31.00, '每日坚果--即时优惠21元', 1000, 0, 0, 0, '肉类卤味', '良品铺子', '2020-11-14 15:45:17', '2020-11-14 15:45:17', '');
INSERT INTO `shop_goods` VALUES (17, 'img/img10.jpg', '羊肉肉干', 21.00, 221.00, '每日坚果--即时优惠21元', 1000, 0, 0, 0, '肉类卤味', '良品铺子', '2020-11-14 15:45:24', '2020-11-14 15:45:24', '');
INSERT INTO `shop_goods` VALUES (18, 'img/img1.jpg', '啤酒', 2.00, 21.00, '啤酒--即时优惠21元', 1000, 1, 0, 0, '冲茶茶饮', '良品铺子', '2020-11-14 18:59:12', '2020-11-14 18:59:12', '');
INSERT INTO `shop_goods` VALUES (19, 'img/img2.jpg', '啤酒滚滚滚', 233.00, 21.00, '啤酒的损公--即时优惠21元', 1000, 0, 0, 0, '冲茶茶饮', '良品铺子', '2020-11-14 18:59:35', '2020-11-14 18:59:35', '');
INSERT INTO `shop_goods` VALUES (20, 'img/img2.jpg', '凉茶', 3.00, 1.00, '凉茶--即时优惠21元', 1000, 0, 0, 0, '冲茶茶饮', '良品铺子', '2020-11-14 19:00:01', '2020-11-14 19:00:01', '');
INSERT INTO `shop_goods` VALUES (21, 'img/img2.jpg', '凉的茶', 32.00, 1.00, '凉的茶--即时优惠21元', 1000, 1, 0, 1, '方便素食', '良品铺子', '2020-11-14 19:00:34', '2020-11-14 19:00:34', '');
INSERT INTO `shop_goods` VALUES (22, 'img/img2.jpg', '茶', 332.00, 1.00, '茶--即时优惠21元', 1000, 2, 0, 0, '糕点点心', '良品铺子', '2020-11-14 19:01:13', '2020-11-14 19:01:13', '');
INSERT INTO `shop_goods` VALUES (23, 'img/img2.jpg', '蛋糕', 332.00, 1.00, '蛋糕--即时优惠1元', 1000, 0, 0, 0, '糕点点心', '良品铺子', '2020-11-14 19:01:28', '2020-11-14 19:01:28', '');
INSERT INTO `shop_goods` VALUES (24, 'img/img2.jpg', '蛋浮动糕', 62.00, 1.00, '蛋的糕--即时优惠1元', 1000, 4, 0, 1, '干果蜜钳', '良品铺子', '2020-11-14 19:01:53', '2020-11-14 19:01:53', '');
COMMIT;

-- ----------------------------
-- Table structure for shop_order
-- ----------------------------
DROP TABLE IF EXISTS `shop_order`;
CREATE TABLE `shop_order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_status` int NOT NULL COMMENT '状态 0 未支付 1 支付',
  `flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标识',
  `user_xh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '会员账号',
  `user_id` int DEFAULT NULL COMMENT '会员id',
  `order_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单地址',
  `order_number` int DEFAULT NULL COMMENT '总数量',
  `order_money` float(255,2) DEFAULT NULL COMMENT '总金额',
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of shop_order
-- ----------------------------
BEGIN;
INSERT INTO `shop_order` VALUES (1, 1, '', '10086', 1, '江西南昌', 2, 42.00, '2020-11-10 09:38:00', '2020-11-10 09:38:00', NULL);
INSERT INTO `shop_order` VALUES (2, 1, '', '10086', 1, '江西南昌', 2, 36.00, '2020-11-18 18:51:25', '2020-11-18 18:51:25', NULL);
INSERT INTO `shop_order` VALUES (3, 1, '', '10086', 1, '江西省南昌市', 2, 94.00, '2020-11-18 20:28:42', '2020-11-18 20:28:42', NULL);
INSERT INTO `shop_order` VALUES (4, 1, '', '10086', 1, '江西省南昌市', 2, 94.00, '2020-11-18 20:30:37', '2020-11-18 20:30:37', NULL);
INSERT INTO `shop_order` VALUES (5, 1, '', '10086', 1, '江西省南昌市', 2, 94.00, '2020-11-18 20:38:12', '2020-11-18 20:38:12', NULL);
COMMIT;

-- ----------------------------
-- Table structure for shop_orderdetails
-- ----------------------------
DROP TABLE IF EXISTS `shop_orderdetails`;
CREATE TABLE `shop_orderdetails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int DEFAULT NULL,
  `num` int DEFAULT NULL,
  `goods_id` int DEFAULT NULL,
  `price` float(10,2) DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of shop_orderdetails
-- ----------------------------
BEGIN;
INSERT INTO `shop_orderdetails` VALUES (1, 1, 1, 1, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (2, 1, 1, 2, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (3, 2, 1, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (4, 2, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (5, 2, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (6, 3, 1, 11, 21.00, NULL);
INSERT INTO `shop_orderdetails` VALUES (7, 3, 1, 11, 21.00, NULL);
INSERT INTO `shop_orderdetails` VALUES (8, 4, 1, 4, 21.00, NULL);
INSERT INTO `shop_orderdetails` VALUES (9, 4, 1, 4, 21.00, NULL);
INSERT INTO `shop_orderdetails` VALUES (10, 5, 2, 11, 21.00, NULL);
INSERT INTO `shop_orderdetails` VALUES (11, 5, 2, 11, 21.00, NULL);
INSERT INTO `shop_orderdetails` VALUES (12, 6, 2, 2, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (13, 6, 2, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (14, 6, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (15, 7, 1, 2, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (16, 7, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (17, 7, 2, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (18, 7, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (19, 7, 1, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (20, 8, 3, 2, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (21, 8, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (22, 8, 1, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (23, 8, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (24, 8, 1, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (25, 9, 2, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (26, 9, 2, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (27, 10, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (28, 10, 1, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (29, 10, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (30, 10, 2, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (31, 10, 2, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (32, 11, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (33, 11, 1, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (34, 11, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (35, 11, 2, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (36, 11, 2, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (37, 12, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (38, 12, 1, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (39, 12, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (40, 12, 2, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (41, 12, 2, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (42, 13, 1, 4, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (43, 13, 1, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (44, 13, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (45, 13, 2, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (46, 13, 2, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (47, 14, 1, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (48, 14, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (49, 14, 2, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (50, 14, 2, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (51, 15, 1, 9, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (52, 15, 1, 11, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (53, 15, 2, 24, 62.00, 1);
INSERT INTO `shop_orderdetails` VALUES (54, 15, 2, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (55, 16, 1, 2, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (56, 17, 1, 3, 21.00, 1);
INSERT INTO `shop_orderdetails` VALUES (57, 17, 1, 24, 62.00, 1);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `xh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '10086', '10086', '田智伟', 24, '男', '江西省南昌市', '2020-11-09 21:24:20', '2020-11-09 21:24:23', NULL);
INSERT INTO `user` VALUES (2, '12306', '10088', '徐聪', 21, '男', '湖北蓟州', '2020-11-09 21:42:56', '2020-11-09 21:42:56', NULL);
INSERT INTO `user` VALUES (13, '11', '111', '222', 11, '11', '11', '2020-11-12 16:58:54', '2020-11-12 16:58:54', NULL);
INSERT INTO `user` VALUES (14, '1', '1', '1', 1, '1', '1', '2020-11-12 17:05:21', '2020-11-12 17:05:21', NULL);
INSERT INTO `user` VALUES (15, '15797651382', '1', '1', 1, '1', '1', '2020-11-12 17:30:10', '2020-11-12 17:30:10', NULL);
INSERT INTO `user` VALUES (16, '1234', '1', '1', 1, '1', '1', '2020-11-12 17:30:51', '2020-11-12 17:30:51', NULL);
INSERT INTO `user` VALUES (17, '', '', '', NULL, '', '', '2020-11-12 18:53:35', '2020-11-12 18:53:35', NULL);
INSERT INTO `user` VALUES (18, 'qww', '', '', NULL, '', '', '2020-11-12 18:55:01', '2020-11-12 18:55:01', NULL);
INSERT INTO `user` VALUES (19, 'ewe', '', '', NULL, '', '', '2020-11-12 18:55:06', '2020-11-12 18:55:06', NULL);
INSERT INTO `user` VALUES (20, 'd', '', '', NULL, '', '', '2020-11-12 19:00:33', '2020-11-12 19:00:33', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
